<?php

$id_concessionnaire->execute(array(
    'nom_concessionnaire' => ${"travaux" . $div}
));

$idConcessionnaire = $id_concessionnaire->fetchColumn(0);
$APS = $bdd->prepare("SELECT APS_obtenu, date_obtention_APS FROM concessionnaire_municipalite_etude WHERE id_etude = :id_etude AND id_concessionnaire = :id_concessionnaire");
$accordEtude = $bdd->prepare("SELECT accord_etude_obtenu, date_accord_etude FROM concessionnaire_municipalite_etude WHERE id_etude = :id_etude AND id_concessionnaire = :id_concessionnaire");
$receptionFinale = $bdd->prepare("SELECT reception_final_obtenue, date_reception_final FROM concessionnaire_municipalite_etude WHERE id_etude = :id_etude AND id_concessionnaire = :id_concessionnaire");
$APS->execute(array(
    'id_etude' => $_SESSION['id_etude'],
    'id_concessionnaire' => $idConcessionnaire
));
$accordEtude->execute(array(
    'id_etude' => $_SESSION['id_etude'],
    'id_concessionnaire' => $idConcessionnaire
));
$receptionFinale->execute(array(
    'id_etude' => $_SESSION['id_etude'],
    'id_concessionnaire' => $idConcessionnaire
));

$APSobtenu = $APS->fetch();
$accordEtudeObtenu = $accordEtude->fetch();
$receptionFinaleObtenu = $receptionFinale->fetch();
?>
